Visual Key Insights / Key Takeaways
********************************************************************
1st go back and review the Visualize Key Insights section earlier in the documentation. If you used the Project Checklist while working through your project, you probably already have most of this complete. Now is the time to make it look good and present.
Two Sections:
KPI
Good or Bad
Responsible Dim
What is good/bad
Where is occurred
When it occurred
The Extent of the good/bad
How I know it is good/bad
Proof
a. Create a GIF showing filters on for "Extent" and moving to "How I know" selections. You can also do it reverse by showing "How I know" selection 1st. Either way the gif will back and forth from both set of selection groups so the audience can see the insight in your gif
b. Screenshot of your nicely formatted SQL code with the results. The numbers used in "Extent" should be highlighted in the screenshot.
More often than not you will want to use Date Comparisons such as
These comparisons are very good when showing movement or which direction something is headed. When you try to explain these in your insight, below is a guide of how to explain so people can understand
March 2020 YoY = 60%
March 2020 MoM = -10%
Sometimes it can be tricky revealing this information in a way where people can understand . Hopefully the above examples help.
DW Example
